package com.woniu.mapper;

import com.woniu.pojo.Label;
import com.woniu.pojo.TeamLabel;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.ResultType;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 团队——标签中间表 Mapper 接口
 * </p>
 *
 * @author xiaotang
 * @since 2022-10-12
 */
public interface TeamLabelMapper extends BaseMapper<TeamLabel> {

    @Select("select * from tb_team_label t, tb_label l where t.label_id = l.id and l.is_delete = 0 and t.team_id = #{id}")
    @ResultType(Label.class)
    List<Label> getByTeamId(Long id);
}
